SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531801 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531801 [ RunTime:0.001578s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (834574,882117,842922,500210,226550,210532,343220,864378,973786,92945,563133,8850,900398,815600,460360,962052,76538,364196,706986,678262,474851,112966,695708,457895,13330,387461,129501,85111,528089,250904,673725,803772,256141,4886,1029177,265959,294910,482629,870159,209665,217433,427256,877546,205813,298648,84194,192432,624191,296063,660447,8435,980017,194769,558715,117091,180375,784461,11429,411792,413696) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001238s ]