SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511726 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511726 [ RunTime:0.001576s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (290614,75566,650384,412253,740066,789785,814495,114378,229816,415373,232822,870412,328990,486303,706678,313850,421060,707195,617181,361118,356266,284187,105672,818020,693646,993794,974591,1034694,790291,850467,521785,147228,116918,437597,606823,987156,545283,1015278,373893,580276,384130,128210,471456,465053,219414,290402,656973,178781,979291,1045160,101759,765174,845594,840117,684638,373852,397333,834952,836324,881435) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511726 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511726 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]