SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 470410 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 470410 [ RunTime:0.004567s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (31362,89182,13059,616339,175818,1033450,962273,365797,536857,49297,467965,38614,383744,356845,983488,744110,138115,917252,632074,128167,165774,719712,880199,1034858,373349,653390,208268,839943,659378,315780,723326,752308,709127,475637,126334,966578,772469,712555,678972,209215,283013,599237,712065,927372,239711,713711,762936,1013644,701084,1027671,249209,675996,593778,54788,377993,509629,632639,620154,29827,730332) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 470410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 470410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]