SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036726 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036726 [ RunTime:0.002177s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (655393,469715,121245,679645,349444,937789,797762,443381,393304,878307,104216,440958,279078,753931,42734,1027683,896028,102705,649921,748609,211248,131215,476059,449032,134141,672869,489060,662163,402847,239641,794452,610462,629927,11001,312201,846090,297872,109021,701500,1038908,260097,746775,1011293,565679,795863,155314,549882,425827,355757,741914,407539,881632,588545,793066,7745,1048900,913032,604127,927166,47966) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001668s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036726 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036726 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000662s ]