SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 454341 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 454341 [ RunTime:0.001692s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (326928,130034,196880,506946,538957,974676,1037236,879217,953696,22054,954252,925777,564901,251009,209077,493866,565686,623102,488010,1006622,375038,697369,671895,94146,116331,333618,842165,754199,825505,283271,389924,583170,932020,172891,324290,873315,938326,835867,460767,991780,364587,864806,821110,375794,155778,970210,38076,197426,149231,606816,805174,583134,578982,281439,552373,371786,475481,371935,665900,175168) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 454341 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 454341 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000520s ]