SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001572s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53481 LIMIT 1 [ RunTime:0.002168s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53481 [ RunTime:0.005453s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (429034,283021,101829,415150,308244,715753,77494,711160,360993,36331,798731,828059,31123,44414,158204,1035149,19238,946989,789046,1009911,764548,160314,14857,1044382,492158,394312,462370,927253,705580,817139,543356,801854,564609,700853,180924,646152,525880,163859,789066,191288,918534,567656,405625,83427,685045,1041950,618818,443157,937884,339544,789032,531969,532229,228514,501894,940922,145727,65009,167658,129118) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002992s ]