SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505051 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505051 [ RunTime:0.001864s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (150197,43641,483094,36251,425826,845154,582013,803453,388660,761781,474755,102647,228125,532564,794949,688839,375248,877179,816034,911896,826801,423004,574099,739040,82708,265281,97359,925492,40531,695884,279941,769275,453283,917340,791901,659524,864971,356002,824465,964729,14924,786198,501089,945752,201976,203241,813153,351341,87700,754954,647371,481327,799348,1021461,451498,234547,462979,856508,411279,137360) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505051 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505051 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]