SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 113341 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 113341 [ RunTime:0.001555s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (57780,803375,119923,599816,74941,305296,498520,649891,520139,742219,484090,881543,293818,1020342,980609,244028,330099,209409,962198,584602,224233,901578,1032109,792304,332715,979352,473223,504492,62929,947936,96013,518666,211615,469528,46027,156951,360565,25660,990144,146406,265343,223163,625993,1007680,573141,98332,308177,553974,450450,852973,675560,793899,95018,650495,683684,382077,38299,416489,132422,275812) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000956s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 113341 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 113341 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]