SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106654 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106654 [ RunTime:0.002170s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (502266,632489,795003,275141,320284,324468,643848,183808,613131,396845,996577,79035,56848,51474,847125,393714,274613,999055,597280,286504,159970,131681,111833,334768,704585,266773,80554,408726,484183,420562,430282,755943,1012254,381177,678078,39142,260865,146344,690318,48812,210881,471093,127847,779346,572992,592147,790268,519110,270938,648751,579225,522138,675962,343883,38349,966274,269925,4440,295903,798450) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106654 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001853s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106654 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]