SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001579s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 190490 LIMIT 1 [ RunTime:0.000474s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 190490 [ RunTime:0.001715s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (692051,243151,118440,208903,637687,88430,765272,864889,624864,617678,370567,265887,23812,551598,769193,553765,327266,918268,567833,162356,232733,195512,636829,747229,60570,829432,770966,844485,864795,130727,973930,213206,954382,532198,569485,541614,1008881,862288,549782,641060,480489,1028652,998975,731813,788177,300688,371001,612710,763096,779809,562490,572701,238676,197982,779551,1036317,852710,935331,161698,218117) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 190490 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 190490 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]