SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 555730 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 555730 [ RunTime:0.002173s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1038470,691697,331981,53071,1023696,860011,768785,645172,468340,988861,214890,647226,929588,336489,619061,290319,54620,770884,1011600,947804,288556,72767,909341,500724,730922,818549,901240,184212,259528,713023,967217,565840,96990,866944,815245,814723,741886,63087,471708,261788,297820,886385,4684,644492,180691,898815,863695,862797,98121,673405,733793,1017098,548841,929572,508051,500049,40381,407137,559880,408984) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 555730 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 555730 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]