SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516953 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516953 [ RunTime:0.001878s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (345360,332218,146856,656867,164591,437893,930733,638969,50236,670447,209472,810625,411936,322386,909055,662871,1018409,213410,11855,298818,948537,1021606,687212,574079,328388,923506,988435,889111,373122,998723,343779,554123,691687,285420,111470,844190,642171,96106,895785,181873,509181,730281,747378,693102,848439,183956,892624,65628,6312,638349,1018743,679276,870549,294063,789620,333717,762479,53741,371307,280272) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516953 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516953 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000444s ]