SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508041 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508041 [ RunTime:0.001829s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (182612,253099,972767,339106,87742,553117,322607,813147,613650,296815,849846,621601,523683,284542,1002588,477253,728748,491821,875762,210170,588943,109593,901521,313538,729394,83595,519604,562406,317293,269306,187912,372800,262617,387375,732830,100543,752939,940241,287011,696418,754301,411669,440393,925453,894487,950911,941036,574897,691783,470743,419065,396437,932150,248798,1026646,704381,741565,800542,686025,196556) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001680s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]