SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 20447 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 20447 [ RunTime:0.001427s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1044036,655680,474549,424230,318151,1035386,251950,107682,511549,865081,935626,531782,902088,576058,349509,698285,569753,166011,55079,620589,1011008,152783,462626,944708,68364,540963,412941,428311,610296,50328,132643,116327,446478,737507,122593,645288,115296,954955,875948,805807,781629,990345,943139,54495,888303,929747,206648,413877,744292,293458,239557,573549,1008496,222738,397443,236901,654812,622596,562233,402146) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000920s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 20447 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 20447 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]