SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 35683 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 35683 [ RunTime:0.002591s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (335452,1011130,46339,56373,598230,250280,408050,1034304,921071,415170,914371,120505,317158,167055,930266,622521,520297,124844,490617,414244,915292,254898,3255,239814,926045,59192,333349,459915,803962,516440,212728,409133,502040,555151,10447,463523,892806,161463,333242,623706,932332,99221,199981,791885,289047,199682,621819,305963,473591,897235,161080,394294,938528,704779,578484,841484,842755,682402,219710,830504) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 35683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 35683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]