SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002302s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017003 LIMIT 1 [ RunTime:0.001062s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017003 [ RunTime:0.003384s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (240750,358802,799663,404442,995101,858685,740811,462370,395811,1006873,609540,445405,958496,865239,54920,411979,124250,104162,719614,405088,712631,939797,758713,165414,521881,886,897565,1484,369182,950922,367359,670367,392946,458992,136271,81355,315048,573185,602004,24625,223043,606166,289022,550292,651982,379255,755181,659107,975856,327322,97080,238507,161114,879241,971557,366654,480973,895540,717450,676861) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002936s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017003 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017003 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000444s ]