SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001728 LIMIT 1 [ RunTime:0.001293s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001728 [ RunTime:0.001663s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (739517,304165,273119,740982,192563,370382,803295,948089,790892,613696,176573,449838,76979,483273,909660,930150,237574,290686,133563,786799,609156,8244,487832,236443,207068,379705,520269,598575,556385,581680,986246,386993,611574,427952,10036,530953,332489,901959,1046216,660843,409961,45106,129465,141756,85893,362245,14931,108987,54370,434126,138853,120726,45759,815307,1035270,235638,630854,567566,73980,561464) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001728 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001728 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000410s ]