SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001371s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045790 LIMIT 1 [ RunTime:0.000663s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045790 [ RunTime:0.003481s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (905766,1045852,1041198,845064,437138,646564,1037126,26564,79352,739550,988695,617091,646960,774382,219918,120228,431070,1012442,591852,902525,96615,255702,700576,413796,559399,869509,960886,283245,46015,161261,316068,984323,159143,799400,343282,591635,521490,892048,604418,437225,109121,324425,971173,319882,573223,558523,426556,653454,155630,326814,307042,857460,1004716,897022,1005162,256579,600614,691121,10088,460938) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045790 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045790 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000434s ]