SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003018s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507077 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507077 [ RunTime:0.002488s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (803018,645259,58108,669734,1045518,247166,970051,137047,2547,1009599,869310,1047616,634174,599528,100647,487679,63130,67980,720200,167305,299723,537259,1037657,837967,495347,42721,550642,269442,532115,975153,604772,727506,395657,854639,475077,969851,48700,623193,799510,569338,77666,547151,814152,667481,117232,1032756,526155,1034106,138039,576537,1036125,1000351,368431,862713,839061,787388,294256,14688,168772,175842) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507077 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507077 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]