SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409182 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409182 [ RunTime:0.001813s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1035406,1009434,834637,662127,215438,743218,901840,39481,835008,294636,456478,254385,626347,417605,349086,655544,453788,166578,828360,842098,128586,335254,877792,751173,606098,36696,166172,223128,917255,1011868,584161,1036516,642275,680880,787529,26608,809336,189130,901953,729454,399625,161462,833925,693939,194881,240546,724982,217824,595375,944223,151502,607519,343467,584674,438113,1029255,645206,687019,227240,369581) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001905s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409182 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000472s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409182 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000641s ]