SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 129398 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 129398 [ RunTime:0.001667s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (253311,206960,448771,841187,81052,574063,557422,343796,280570,714910,866155,540929,164931,959737,401593,527376,72771,96379,661440,839191,778288,453040,1006946,806043,378578,1000068,932066,879908,596978,343414,652162,234842,3064,1023713,812936,374880,567874,605503,507220,724735,980780,228823,136739,773651,373550,255358,365290,180789,260893,300820,278810,242355,912430,994219,898828,74982,707663,114956,320001,19775) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 129398 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 129398 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001646s ]