SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001513s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045443 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045443 [ RunTime:0.002808s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (782992,36772,786224,1018629,939975,969265,848236,6507,883603,881773,85211,706098,73397,912434,387569,250894,919566,1000443,1043071,389080,750815,954974,130430,303014,138606,998256,486163,1013046,873334,388845,420273,16815,632346,174165,147353,743655,572311,393920,453501,272048,21677,714296,312322,408780,829054,119932,331312,887065,142833,915365,476352,1028581,582270,945710,13251,14698,467587,256214,856749,943629) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045443 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000519s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045443 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]