SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106328 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106328 [ RunTime:0.001562s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (43632,867891,1017519,259473,204717,1009983,688598,521240,749453,591011,77030,680134,971853,468649,30423,463599,91922,402158,600022,323076,735636,323318,167827,582639,187721,275575,852007,275560,389013,426999,61100,541519,636185,15738,335050,512566,810706,92043,37369,875876,480274,279879,250003,909017,518992,1019206,992464,221554,249904,527547,245477,935502,503228,816599,873923,149286,264732,282809,779286,803014) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001860s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000452s ]