SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002050s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 300919 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 300919 [ RunTime:0.001712s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1020311,559885,235009,495900,233434,546972,347647,14399,383572,69049,506615,532739,284595,471590,465508,792967,358993,838543,111776,755644,712521,554725,58874,1014874,555193,448130,747485,238803,987312,178238,669736,302092,47451,923560,782575,628549,994769,861247,450364,969113,445274,735951,767520,738656,410063,668900,634008,372816,443626,965084,826547,281846,765391,934494,488466,906143,486077,958429,703904,882287) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 300919 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 300919 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000708s ]