SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103315 LIMIT 1 [ RunTime:0.000463s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103315 [ RunTime:0.001821s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (514024,337221,363820,461602,942125,939116,692824,1011991,576258,495742,156106,852281,335619,599932,465983,374202,821144,66305,667190,872288,193861,49237,88669,891846,461653,534175,881671,563414,327213,260157,891205,971925,681246,833713,638439,824364,452094,778623,936697,836240,438360,487851,571289,789154,457775,873485,173311,516726,465011,664872,739538,1020447,187848,1013416,153437,598058,732773,564687,447304,995041) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103315 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103315 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001818s ]