SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001539s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104438 LIMIT 1 [ RunTime:0.000496s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104438 [ RunTime:0.004752s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (890755,94835,420113,656650,917018,197208,694240,845070,776467,373667,275271,205684,851810,706866,726663,200945,877759,310651,792043,266602,975016,344172,47498,778402,470044,541810,457060,174072,513471,560622,592618,173218,575087,929271,794860,716066,380146,502471,959563,77951,867842,999726,631010,255011,607876,756422,453796,918292,396448,985998,364940,799127,212,998605,138904,617727,662400,242148,703648,708578) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000598s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]