SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 304811 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 304811 [ RunTime:0.007107s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (430424,560814,588922,902783,901116,252755,674237,730168,362874,448591,488970,51112,18933,27566,989359,295294,47375,583862,395684,724652,331842,247838,482973,141411,712551,306495,660605,351694,940615,303710,67114,876362,455880,519296,798293,356520,478739,285721,766319,93614,140663,837197,777374,604702,284145,220994,637733,703805,814323,539760,318127,846375,401010,653417,111381,128065,997445,826010,696551,203311) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 304811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 304811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000451s ]