SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 555341 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 555341 [ RunTime:0.001664s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1037809,870395,166524,86784,366037,59554,222082,589893,944503,713723,563540,367251,565209,142406,90954,31372,738478,507596,831146,133394,674867,846879,614178,76200,408144,831204,448482,590735,185149,870242,715832,104006,812648,614166,538757,284257,647374,587251,310545,468215,885484,54815,965962,520070,514512,53434,912928,792308,188836,194425,839325,407941,822228,662737,526785,438009,292871,239344,276182,847027) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000955s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 555341 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 555341 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]