SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001917s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039140 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039140 [ RunTime:0.003160s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (988465,440047,673125,655964,212724,133866,986503,75991,904399,950660,987541,320147,769888,576600,899142,94390,1014136,73543,735343,1009556,293549,118207,24562,568348,1000688,302898,61923,512393,47708,475975,250080,215876,659540,399164,482473,576667,302160,708478,137879,1037300,752840,900833,505807,937486,94372,814590,444672,83415,900962,791465,578562,726815,109146,778750,65758,800526,660644,830849,1037063,512467) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039140 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039140 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000418s ]