SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341931 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341931 [ RunTime:0.001450s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (217419,617326,944165,231041,510623,435698,700329,822364,838628,333088,240780,118136,1017460,919182,610383,548869,296180,852398,181643,245433,249580,191303,135974,189433,793146,102813,487079,166786,357167,399528,293019,632731,889705,931513,951006,37415,34545,223827,50496,430752,111900,408059,99989,428932,32660,73118,970786,805727,843955,939804,622481,345561,995409,686657,751593,396385,192679,12187,551711,291483) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000944s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341931 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341931 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]