SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415053 LIMIT 1 [ RunTime:0.000458s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415053 [ RunTime:0.002316s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (286579,762188,992468,791015,67293,985821,950575,603635,312227,246192,235980,1023982,636041,636986,488921,523127,632176,178548,785854,1027931,899264,221643,516367,371822,371528,1037342,386843,671850,790986,961989,942314,358899,283620,987489,130073,572830,480310,695571,472302,226353,541029,737009,943397,526155,357039,661810,62594,945392,904124,244267,100932,248733,148106,613962,714512,205389,964997,390164,208957,30455) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002147s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415053 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003209s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415053 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001225s ]