SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001529s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467213 LIMIT 1 [ RunTime:0.000593s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467213 [ RunTime:0.002159s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (231784,573450,307011,24777,590266,574275,6208,759510,52992,1034539,695893,88066,119669,470542,454354,512876,296627,704909,724868,78180,635044,411576,695561,1046697,356878,335709,212734,578258,260551,116489,1042645,720806,276197,212666,463112,994625,458620,122753,144049,443450,234588,94410,944276,913263,856099,701926,227186,563663,832718,134735,360514,221809,473000,134025,935243,696937,458307,286701,903992,475137) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000955s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001720s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]