SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106896 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106896 [ RunTime:0.001602s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (843027,280837,46865,487064,694190,506436,895257,426799,292398,91742,787780,903516,794984,414681,1034055,491609,594230,1033612,52970,487829,389362,215676,678087,574001,250033,796099,842405,560698,654141,633838,182851,196485,19212,51914,329691,250387,990970,92513,78502,759401,1015784,704649,186728,649249,130634,187799,485509,926292,615021,660415,932860,356759,320186,735648,973172,220961,134910,941693,463985,198351) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106896 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106896 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000725s ]