SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 58139 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 58139 [ RunTime:0.001877s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (534328,185870,525322,259114,1044050,483544,997042,158150,56406,367821,325166,581115,869393,394294,741268,260752,924405,543305,936946,506351,707055,157402,418596,142526,487142,799788,240881,667453,1011311,594829,956199,374780,611529,127973,528637,662184,1019538,110218,738816,797790,178561,623054,519961,378871,416101,745860,846335,542434,1041774,1010984,673335,456539,395768,364981,330421,303378,150314,963654,435044,152329) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000953s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 58139 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 58139 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001002s ]