SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427946 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427946 [ RunTime:0.001695s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (236768,378304,393240,956485,100755,575112,39575,116418,499754,192994,802502,463207,967279,143818,557721,966795,843401,371877,405936,281788,386734,327120,602297,968702,868382,624573,484768,325553,9391,191680,1011075,365199,575311,915942,88664,33737,35542,855554,684073,102886,708289,163163,691355,5444,601136,782336,42115,865360,533558,397779,986448,114008,737056,527884,615803,452213,368567,1016551,138271,896506) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427946 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427946 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001163s ]