SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 134101 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 134101 [ RunTime:0.001509s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (507138,754364,479019,350172,198832,383575,920950,171541,436104,161725,454014,325431,1011981,259770,105755,641852,382056,548847,536740,916421,525805,379506,625431,725685,381486,500834,406428,636447,661835,322059,304583,77711,659255,437114,792476,769739,858605,674977,977838,496293,801042,536069,1005211,41821,677488,669422,344823,986574,871475,622254,152038,666529,54522,569735,30148,995564,38918,876054,793785,532838) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 134101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 134101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000420s ]