SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001449s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 322147 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 322147 [ RunTime:0.002093s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1019103,788880,525128,612537,816119,143689,89159,829304,638134,770154,913333,589691,437640,199397,271596,320716,630720,1012682,902186,393604,49589,1048684,714189,538435,310049,110175,231346,430003,22917,977404,933694,73860,730513,191844,237600,248394,155650,983932,156478,660862,292367,897622,301267,740570,448391,576233,432558,735790,303980,79292,814384,43065,418409,977987,842672,448026,300342,856904,554794,1006801) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001869s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 322147 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 322147 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000690s ]