SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001567s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403611 LIMIT 1 [ RunTime:0.000423s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403611 [ RunTime:0.005902s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (516745,512947,243566,994695,516423,742833,829899,894901,811605,957259,199668,91997,776773,987546,559640,938440,973623,524236,140174,361940,1022114,280602,593736,661789,897779,950493,34263,14928,101631,159979,128148,477664,542458,89443,735050,984859,880808,181242,1044203,1017295,615976,287264,809585,733004,807930,428347,393171,354918,646953,138199,167668,241398,478091,173533,752017,2476,399541,885465,311534,912840) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005893s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403611 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000898s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403611 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000678s ]