SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541310 LIMIT 1 [ RunTime:0.000892s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541310 [ RunTime:0.001395s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510799,810161,54721,871151,13331,16495,603382,441807,145670,417915,367610,3950,21394,579839,414918,142426,811565,978102,615331,1037294,523663,971226,466803,398319,286452,772877,6286,741198,824001,784279,31919,253202,772844,767730,125036,504916,953174,797971,382591,790350,271288,342010,36974,609765,297793,587275,461396,514757,814907,175955,136813,561186,756586,40695,631371,47512,928308,507328,164219,180073) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003173s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541310 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541310 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]