SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502571 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502571 [ RunTime:0.001613s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (560652,820723,482138,86441,576468,894962,591545,388455,345855,786268,358578,1040861,369251,761209,636541,330451,822961,810843,909022,739425,56691,249567,719131,256859,705690,257864,326854,820316,201537,370418,964044,1032021,769596,1002836,425773,412344,674753,920067,676983,775321,84023,470722,692731,312328,310917,355615,791442,417010,422445,959340,24991,66032,576001,570515,415443,581202,317233,568734,429977,973862) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]