SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.007811s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 556948 LIMIT 1 [ RunTime:0.000529s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 556948 [ RunTime:0.001825s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (7273,850098,376075,230367,296852,945244,319152,466675,612009,197753,372052,216005,441709,771129,936156,318183,679118,361580,285810,947777,868985,177729,746146,168890,784477,445474,39651,493884,326002,914780,771912,497764,241293,450908,151427,335669,1015683,937012,568696,699134,1012849,446201,782817,167984,65843,156809,788735,578393,510649,248539,482770,395992,311079,862899,378769,392533,104834,683720,384865,449033) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002709s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 556948 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 556948 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001564s ]