SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 194370 LIMIT 1 [ RunTime:0.000799s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 194370 [ RunTime:0.003066s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (415601,928365,773330,798702,513445,674220,261207,917924,781957,367770,311262,948680,978607,728257,1010753,660143,133714,900868,1006531,287915,1046768,172323,39016,767155,1038739,704836,979128,1005602,794198,107192,79468,148364,495744,57630,591757,275539,611440,430151,905444,362499,639372,771458,226616,342340,586457,526923,46511,1005923,591437,676191,848299,773101,978313,550837,619150,538762,530630,464518,746161,8001) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 194370 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 194370 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]