SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 568591 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 568591 [ RunTime:0.001675s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (996380,109788,813588,562337,1026117,39490,389632,17043,643530,589386,105798,771566,860485,828598,539208,927236,125825,1040812,612505,538933,420671,18094,127544,41718,364026,773760,708601,731093,421412,234775,969211,740651,900932,419571,287359,659292,679904,722618,1008366,938894,179080,409601,491669,461762,59575,40885,206508,48574,293243,786352,272728,88040,1028016,683832,968246,676812,73665,424645,694872,80452) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 568591 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 568591 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]