SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418556 LIMIT 1 [ RunTime:0.000432s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418556 [ RunTime:0.002676s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (228805,201009,252545,506386,301060,983489,19310,408185,436103,795553,335362,867991,507463,482967,625407,278304,836429,430391,133693,61993,507217,9468,184553,595301,580180,136323,375268,346464,942180,563805,1030927,98362,21581,269482,284892,472034,908328,279527,878493,721225,1017507,562490,4469,703026,837200,643451,331409,610329,708088,249587,465064,1026090,74872,1032053,710726,254011,678357,351965,498681,777287) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418556 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418556 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]