SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531865 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531865 [ RunTime:0.004799s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (109715,294775,821898,638547,261209,782966,91828,900153,479683,151550,301144,89673,1047281,235615,335929,689819,593480,458014,1047639,780985,181911,725540,446952,96139,752187,197680,999628,173992,896809,645184,130241,352940,884475,637277,395287,425696,703369,334644,935863,612899,328714,630108,827159,921200,544422,604099,27352,372635,205000,696838,95671,727520,314609,747925,258362,152140,553414,707175,658660,555967) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531865 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531865 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000483s ]