SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001314s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 833403 LIMIT 1 [ RunTime:0.000432s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 833403 [ RunTime:0.003600s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (455640,1015580,935424,148163,685327,191187,336719,834479,473555,595744,468661,954250,417334,717386,129458,203476,871095,1014,429360,520274,310143,1018598,1018979,331370,524242,2313,90646,111778,940029,37440,720869,576311,1030103,1005888,658864,422511,799294,29296,583642,662511,524520,490138,362649,141048,161341,307610,220678,766133,952827,797330,643374,39704,687330,412834,86393,405781,274094,687567,220350,779937) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 833403 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 833403 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001142s ]