SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 454016 LIMIT 1 [ RunTime:0.000454s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 454016 [ RunTime:0.003384s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (21139,797300,751339,993793,819851,194079,718567,528682,499437,518363,671096,938449,906791,427274,93131,720076,835897,844018,687815,705809,727338,634071,346383,233532,706104,701893,1014214,95012,211870,767663,605774,379278,430573,235619,546432,407481,98156,680654,357463,436366,616089,474487,957820,1031150,389175,234251,509382,750166,517103,298839,1012783,220356,1014581,747483,25235,981033,571305,111511,182559,166937) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 454016 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 454016 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]