SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014458 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014458 [ RunTime:0.005905s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (489916,888327,448586,900748,519532,206111,260998,87164,305397,448199,1038125,309412,6159,159223,574584,567550,425178,652205,62890,578207,967696,1041164,97636,401162,352155,563290,900241,204987,87775,542362,209936,1026012,503050,363809,894738,189729,398697,492791,582064,1041063,17456,780487,761511,747850,574212,527842,255331,895958,725940,14500,985538,688624,257247,654557,900424,558505,988303,114185,914287,739846) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014458 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014458 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]