SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001328s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 331780 LIMIT 1 [ RunTime:0.000429s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331780 [ RunTime:0.001653s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (542833,225314,407472,231986,586008,658952,127708,1005572,691749,134241,944036,132820,320760,703943,263070,926215,475128,37989,883967,742328,745853,37189,497966,268757,849046,953867,766108,729630,50432,692110,1026156,645861,959231,295289,1044446,239610,827012,577629,796235,663595,314780,493546,340737,355753,922428,713245,427692,29544,77083,196841,729080,510867,697028,714738,275887,259652,241166,90366,791329,195578) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001608s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331780 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000544s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331780 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]