SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001341s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429025 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429025 [ RunTime:0.002064s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (380023,973414,536599,227701,518239,1038735,755199,278180,363920,218300,120581,411120,688738,957526,135811,596810,868671,288499,963221,239786,556852,99942,283152,927359,24361,265559,630293,940719,583555,74911,1010322,643989,502300,674788,791220,872741,1008873,366064,930188,512211,349165,349635,841857,664501,176043,81554,973192,422203,336620,187543,945314,499318,998885,1016621,434578,30960,696584,955436,961480,653908) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001542s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429025 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429025 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]