SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105293 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105293 [ RunTime:0.001527s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (781133,900922,254598,1039174,786423,244486,740887,71175,112070,4646,847201,928165,778629,55225,188158,204363,897117,703914,204084,928404,828750,986283,775037,282504,133726,634504,336527,275678,631568,90820,228476,151476,656257,595621,961950,1037267,708590,393793,94788,361359,897980,336233,813568,758399,754483,767986,180049,225308,284510,576138,63777,843016,522447,892891,922898,678490,637109,761115,860343,502805) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105293 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105293 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000648s ]