SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001956s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 39188 LIMIT 1 [ RunTime:0.001124s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 39188 [ RunTime:0.001796s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (198616,465940,875974,479835,766509,127251,720877,540962,124206,845248,1037503,299028,945222,209803,990340,831586,370595,955144,126335,1035823,549585,61803,701509,446229,715313,782062,79741,330524,457146,278368,114275,211459,560313,171223,584665,233402,113538,970665,318286,41348,718471,234375,13214,118795,72524,218686,881699,997186,79947,780607,720422,40772,282253,789322,75410,913796,846852,933690,192214,1037745) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 39188 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 39188 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]