SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004541 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004541 [ RunTime:0.005675s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (430590,992133,32496,853579,141640,944022,447838,592215,375310,735523,720613,1024017,95138,982615,169631,67812,575465,126142,747623,893709,100316,644553,133743,794278,75984,966885,73647,709183,406968,482085,834951,864718,744361,172509,52363,221152,242197,613025,365272,623549,807901,209683,340388,543389,962147,761894,273914,377402,729548,647611,137835,726135,374058,205363,644382,654907,803028,736075,40244,375311) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]