SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 459627 LIMIT 1 [ RunTime:0.000284s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 459627 [ RunTime:0.001565s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (103880,1040018,811860,596474,116805,160194,110413,458811,474602,1003334,204837,23014,674180,1035141,442264,507298,624264,105133,270510,354559,580961,961362,875105,379665,670783,371822,1011969,675030,56187,668406,827402,1046281,87253,708437,629796,654315,58429,682618,122105,789946,488938,140203,1013764,60658,225616,19178,568830,513065,392719,956256,108303,380774,400734,463225,727471,792354,588722,37091,1012107,676057) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000973s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 459627 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 459627 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001599s ]