SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001358s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 585014 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 585014 [ RunTime:0.001629s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (464897,580749,870705,439799,162657,827141,225835,935441,1045495,709493,389213,965822,193642,909344,682380,193372,1003875,848531,324973,284340,975844,263807,102482,645116,739713,599117,120077,170295,156744,748438,355889,1045073,311079,950951,465501,209896,537391,337031,275863,91473,706980,100180,316812,34383,366937,628763,284117,688689,580365,468128,317019,572826,618886,517031,872483,859399,422017,325739,343660,32177) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 585014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000472s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 585014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000743s ]