SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538515 LIMIT 1 [ RunTime:0.000630s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538515 [ RunTime:0.001729s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (643157,980024,112887,681821,60271,382060,596995,965468,343454,929826,894841,7443,997839,995683,754763,283045,847603,282441,608067,448242,421164,185995,535736,207901,827804,504012,678136,440494,1039407,811475,214731,599155,684494,360035,220962,104428,977091,365019,841758,938863,305177,115369,444237,8200,70789,1009851,185024,15352,476374,118463,365976,259845,472434,366993,763168,565364,110231,104301,632550,637149) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538515 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538515 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]