SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40200 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40200 [ RunTime:0.001624s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (583803,836135,385419,344852,311502,924508,701098,166578,192934,64053,339271,779288,968086,370823,828764,895518,4158,265283,435801,711997,875511,916216,129050,606422,75025,222289,166039,890298,13875,197242,86942,847498,970939,229657,243895,264607,177215,361886,297891,331703,67484,897959,191742,301518,403255,331919,518478,727665,456732,137914,710894,1002216,953509,778224,728603,871661,161950,272105,762647,900246) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40200 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000671s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40200 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000816s ]