SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002805s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 392523 LIMIT 1 [ RunTime:0.000473s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 392523 [ RunTime:0.003499s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (698017,150398,349831,1011708,734204,903148,936263,481613,203115,215831,418027,977337,846226,633219,30379,531520,413596,141524,866271,605113,151624,707795,668093,822863,941016,294080,39837,1018955,144467,890822,621188,588873,63196,1027896,430765,268062,696709,151382,933193,437197,231833,872458,644678,550895,5072,109607,556524,928971,469292,17764,44467,623662,696502,496794,464994,818050,59273,747630,476032,756491) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 392523 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 392523 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]