SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001852s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 488053 LIMIT 1 [ RunTime:0.000760s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 488053 [ RunTime:0.004894s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (661684,959045,220983,194471,920104,521089,726747,1011387,910760,837186,551998,456097,752463,825231,599920,361657,14044,200259,342449,1003487,773421,189569,132027,699778,868153,780378,620797,222737,618586,288333,671810,509040,558761,685240,158402,23577,217339,239246,416148,861348,897587,992851,119238,223017,418123,647511,337187,665002,786705,483905,151990,645362,82917,908796,446945,580234,817426,733998,747611,45787) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002849s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 488053 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 488053 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000473s ]