SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1007217 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1007217 [ RunTime:0.001917s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (906638,750133,56793,604295,415640,198943,235521,811087,143596,263844,105215,237388,98698,534158,186918,217711,786800,763005,880873,507286,729308,622512,263527,97634,455223,474516,793117,1026018,39397,668732,953668,932409,993598,300880,876853,344742,715384,774432,460126,944907,949926,174228,797459,340495,354611,788406,450221,792,128761,1036014,1047956,1040409,917463,774517,465929,467321,391716,829392,967833,207790) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000984s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1007217 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1007217 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]