SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 454134 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 454134 [ RunTime:0.001918s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (407018,911078,118022,662178,356147,479360,684933,868307,801140,465268,509255,255400,3992,363878,337190,260730,374503,173489,438164,564041,229071,456658,718588,965447,615537,541726,687642,117103,882090,607633,946500,649946,73652,549884,783626,548345,600946,853510,385772,1028140,104795,704108,963966,717096,660845,370576,716230,50686,795976,372981,849903,287590,43615,321062,1037152,82937,602022,176872,615780,1030770) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 454134 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 454134 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]