SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001615s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 588078 LIMIT 1 [ RunTime:0.001203s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 588078 [ RunTime:0.002011s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1004359,1004412,311882,353639,61948,374033,527287,215533,195607,328453,479104,124048,962279,817358,691263,264808,598580,119970,256803,814315,552667,73117,154063,746938,768282,60669,495684,337030,447327,351265,819447,497287,941594,131768,740846,529447,946419,463759,578243,93296,18279,853079,647245,717550,103304,278495,67332,1018078,103203,985781,697808,883891,710734,955140,173946,891993,737634,464952,881890,526234) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 588078 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 588078 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]