SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 651409 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 651409 [ RunTime:0.002427s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (412902,718999,167943,289299,174601,328515,574383,98804,480671,926873,785953,523993,233050,814907,215287,30330,1041776,478973,284544,5850,769482,314317,254210,86486,433586,368931,953106,738574,674070,14364,467562,990774,10454,311857,41502,1010448,756791,398834,768979,479592,1008070,385306,835397,235393,700566,1028850,118389,545593,59013,741168,355061,360834,825373,3774,289867,762733,1018939,250520,684894,971712) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 651409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 651409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002429s ]