SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341154 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341154 [ RunTime:0.001640s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (406650,944975,600581,97454,204705,208140,822060,503609,510982,12456,604663,301820,43654,229583,774077,957592,1003363,94948,816516,1034545,533419,538652,885867,514788,1031854,597417,770587,829148,109206,553672,391823,848924,465653,864799,639878,933042,978829,350809,424126,540515,818730,425727,317042,553880,641214,424494,37639,343180,424410,805815,577593,347445,729086,568009,607178,8660,188458,1038289,820543,341924) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000956s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341154 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341154 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]