SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 901428 LIMIT 1 [ RunTime:0.000755s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 901428 [ RunTime:0.001823s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (424366,622648,1029454,827198,817109,930552,842734,493147,316560,991473,168338,743691,529095,999199,154602,691561,836946,401798,634105,812582,85090,641121,456643,488426,177745,509477,374867,19379,528820,124394,4714,516580,56067,213195,528861,677439,66332,114003,1031672,680910,577066,259836,39211,764478,249993,97557,149802,984855,114200,33743,330623,924615,256648,1001646,721033,150617,957538,233998,185342,66313) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001562s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 901428 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 901428 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]