SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 45018 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 45018 [ RunTime:0.001533s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (488021,397133,811289,412194,375485,965069,167940,96110,1013828,44356,131042,160623,84126,548925,344721,539076,23479,874522,295768,595551,674300,1042220,808302,653775,714457,327258,602315,262689,567190,864351,461185,1008074,610124,21549,250439,599639,644891,552428,141003,13609,313870,493260,289691,1002851,397277,389669,71044,203933,977,362422,846822,705156,944899,565480,327854,802299,357022,543146,207077,893313) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 45018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 45018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000456s ]