SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310623 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310623 [ RunTime:0.002229s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (253919,789981,1047251,822079,157438,680903,1009326,254995,155312,476618,646130,522396,798289,227029,680365,194513,758159,772784,65540,556759,392644,417262,258371,897622,413668,828999,731119,692846,154623,679320,1642,872533,281568,1045972,1031691,387006,1017319,632864,914698,299314,279699,847570,712977,25078,749409,385398,788217,865180,43385,62049,56287,423249,780370,184098,540309,834561,60057,342042,835881,171967) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310623 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310623 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]