SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001791s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501477 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501477 [ RunTime:0.001652s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (697286,150435,1031139,845223,860311,818445,488079,258977,32827,702305,308127,703399,596943,948728,737616,686640,28210,369098,198771,276847,293611,679624,331959,362679,274263,619613,568092,656502,860798,978587,1025602,1016586,606560,653501,20507,620579,996659,160100,727453,105010,167780,1009821,831083,704007,605801,901179,256896,420035,547923,877068,848185,611275,862768,650443,561325,235864,487319,930865,750061,1027584) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501477 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000615s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501477 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001651s ]