SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 631708 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 631708 [ RunTime:0.002256s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (592672,1043626,797709,404473,760457,882477,68587,905298,401860,295361,552635,1044714,947015,502556,504010,110966,548309,298530,772622,899135,213384,604957,282830,865735,467390,420425,503598,462723,177424,996334,994178,434018,1021210,648329,970003,758886,917231,211050,774685,409880,944874,582838,919542,945995,998716,176484,267184,168538,86257,499800,762019,482730,933989,813362,92091,525964,149704,717673,690766,163302) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 631708 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 631708 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002166s ]