SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018819 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018819 [ RunTime:0.001449s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (313517,827714,85238,494825,745346,244194,562184,347238,200660,14269,575256,674055,30583,758671,730571,1017032,329781,586512,827809,42764,864869,651980,990855,809361,132214,693177,308493,967711,246394,630904,58481,58507,107215,1028516,693065,632510,910308,946574,308551,869158,1031018,627682,913884,134428,696814,1011796,115862,670323,520544,798993,30531,914714,217315,292306,252575,86023,814561,124073,841366,117830) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000978s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018819 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018819 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]