SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1008813 LIMIT 1 [ RunTime:0.000283s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1008813 [ RunTime:0.002103s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (412557,329847,197255,586802,789757,779660,108771,824341,709559,471658,434538,369395,757582,145542,1024339,981286,896190,798918,351649,669239,399672,173858,441621,660244,360885,31685,200912,941811,438147,921807,104747,674754,494423,166572,803729,615077,262484,431919,308217,1039683,974752,842952,169199,314814,648870,516053,701390,216808,747257,258233,970781,279991,1045654,350010,691577,785241,304806,229510,639595,148151) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1008813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1008813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]