SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001612s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 486976 LIMIT 1 [ RunTime:0.000439s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 486976 [ RunTime:0.001682s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (642184,627336,286923,130420,134657,850921,232586,231577,143053,345647,983478,96910,15229,652700,236265,910913,696513,456583,577263,557245,582587,145083,158728,502077,820668,991221,711742,649159,627296,152876,53865,429747,857270,124669,479830,653103,1028837,1013881,631134,833125,1047639,289907,904459,1014049,148383,310303,627540,834201,634409,525253,561547,376525,562364,959568,777751,95405,357712,57072,119915,1002426) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 486976 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 486976 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001861s ]