SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043706 LIMIT 1 [ RunTime:0.001268s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043706 [ RunTime:0.003217s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (96742,288424,150699,647300,371697,443353,801437,35920,961759,546402,193852,733208,79351,330104,324026,881653,287383,453386,401886,114219,936548,605819,1025810,351989,720993,485782,1027138,1000682,55047,960623,707398,127005,472252,412156,235020,609732,116224,417719,616040,644144,412515,203234,956576,202009,1035448,307237,883340,893668,55873,241448,916222,777107,38726,317367,124173,555786,366683,372359,659808,562008) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043706 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043706 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]